-- #lazgen HEADER#
/*
	spGoalRequiredExpertiseList.

	This procedure returns a list of all GoalRequiredExpertise from the database.
*/
SET ANSI_NULLS ON
GO

ALTER PROCEDURE [spGoalRequiredExpertiseList] AS
		
BEGIN
-- #endlazgen HEADER#

-- #lazgen BODY#

SELECT
	[goalrequiredexpertise].[Id],
	[goalrequiredexpertise].[GoalId],
	[goalrequiredexpertise].[TechnologyId],
	[goalrequiredexpertise].[Created],
	[goalrequiredexpertise].[Modified],
	[technology].[Title]
FROM
	[tblGoalRequiredExpertise] [goalrequiredexpertise]
	INNER JOIN [tblTechnology] [technology] ON [goalrequiredexpertise].[TechnologyId] = [technology].[Id]

-- #endlazgen BODY#


-- #lazgen FOOTER#

END

GO

SET ANSI_NULLS OFF
GO   
-- #endlazgen FOOTER#
